SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451484 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451484 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675702,495106,638107,839460,826473,727978,273159,769228,530044,915008,313318,540754,205433,59674,508900,4036,476296,545531,262096,193651,24801,613967,159746,497358,379210,497920,440505,951087,599670,535685,1042489,421662,1043035,665578,108216,755746,762861,589752,441431,681214,143553,1016388,225748,35085,405575,460408,525128,510459,944408,723273,591943,153598,155796,28130,693894,322761,352330,746725,639475,1033631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]