SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102213 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102213 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878881,628673,663002,192661,640673,1039773,246269,737893,913063,906984,955950,744971,308353,983412,411831,267140,985496,589505,702242,375459,378972,745039,754908,449961,582996,274584,179630,463950,762972,822042,715938,436860,689509,511746,368576,672724,230379,297727,271716,177543,999854,859847,813984,459976,917762,120084,930886,800343,527600,866760,713470,187983,905765,910477,448957,71986,429099,283067,408853,408929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]