SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310458 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310458 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698483,380339,932953,435346,214318,358202,825267,113087,1019867,671090,804868,679880,132253,545257,538774,536063,137007,55071,26034,694913,125315,511995,1003867,278264,836492,970612,279196,402389,142781,55286,152844,172001,44168,306136,940753,103639,261676,1046725,971008,417520,501228,759635,12553,899483,270171,994931,817951,630523,823076,423761,318810,267554,455051,137014,455551,529505,406780,572387,352234,614544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]