SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045973 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045973 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254356,719618,101660,681754,99475,338864,890657,54178,47701,245811,745202,555700,642201,775939,95387,698567,740852,825564,44910,116285,392893,999677,522572,482595,395307,200397,513782,60068,662217,264992,296390,361824,843847,639207,818104,153175,344119,280962,554938,503086,112928,700562,329136,706415,486667,138885,153489,63251,691203,713046,342988,29771,588694,201316,522044,419367,256956,101443,481301,703591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]