SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287823 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287823 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570190,240213,1022311,975616,817059,74502,17558,29962,391298,312240,375347,363103,854519,101974,86825,772074,20246,223766,871500,821364,810585,686128,859619,381938,574303,61250,814444,89681,217261,781799,1023644,914981,86109,507036,711737,318006,354617,695947,441425,1035877,375387,467882,315164,748405,759836,157635,108242,486519,249818,148117,788489,244030,420600,1041952,933848,107734,418404,725993,802635,736346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]