SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042601 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042601 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967142,686477,936122,612103,64087,750719,346119,243634,105964,575173,86720,727111,212107,661201,76809,791812,740794,1028558,21954,372538,761416,478974,443636,109684,342964,826585,1026865,96914,396042,1031539,36509,686262,603909,108171,297412,250050,333506,405312,217615,623760,242963,822774,29713,190244,661991,903335,806678,203128,723852,616265,746455,550508,432627,678513,631379,913865,377043,999512,975474,695052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]