SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311218 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311218 [ RunTime:0.003046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139872,315870,777033,608858,605779,445826,422826,90363,829754,940070,979334,384906,288146,107255,700364,1018862,713071,183661,587036,415961,393485,31392,979260,710195,483240,416106,283784,150192,55724,1030175,71660,451640,147210,131060,14832,188264,588919,894778,293148,139107,806356,794881,970802,125324,116333,765373,590071,485100,920255,858696,742482,143224,837007,504119,1002457,220061,81768,299161,755719,837965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]