SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460847 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460847 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427889,702410,777472,16730,840622,178715,990812,176648,129489,242289,962430,847370,529695,934676,484354,217393,779691,200915,130937,48843,881713,795695,528793,451168,809732,864451,433421,515320,805380,916318,104512,578244,395934,743893,14154,464259,71894,552574,218997,342709,862303,780413,47144,557266,954789,598918,552937,673861,1044721,543744,925828,313292,719373,1004117,88143,214887,735163,540762,256004,781258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]