SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596185 LIMIT 1 [ RunTime:0.006664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596185 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349782,258490,467906,932633,557130,329361,388828,941085,403341,909143,422551,220827,997743,19469,679804,1022101,1018703,40772,892549,338569,156602,313032,776899,1008731,571247,887906,932999,114231,517269,202605,125830,487508,429149,950201,22540,834982,47191,992449,258509,1025485,292996,192374,939455,338857,715677,645283,820230,80782,778796,490515,333780,8260,542801,838185,1003129,477293,786138,711997,535987,1016974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001413s ]