SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005728 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005728 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015400,709418,715262,147606,232621,713538,857968,760901,615966,16591,103557,513792,449818,797084,514226,871586,1025113,603151,1042563,645047,944754,771710,865465,267372,319232,793462,687941,405087,909249,648500,262080,285607,255963,395666,75850,573153,671671,725278,497373,327997,609436,266781,827684,764181,142720,855055,68348,716565,44074,276977,187188,962190,957282,645477,321728,449027,244940,594255,594186,1026819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]