SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287591 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287591 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56481,635149,82749,969341,148650,809918,39893,693956,571524,1022751,974973,183168,687720,681383,1018340,590133,861106,178515,957764,1006184,217465,435959,355099,41121,80689,32430,17199,277628,493445,6410,111851,220775,491491,751322,882354,148397,878361,973013,750807,394629,634629,212211,593559,18119,262402,22475,147155,815323,933435,898748,419918,835012,660603,549187,89272,35718,18710,907481,79370,369141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]