SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744028 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744028 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690655,172180,492077,411614,540262,720598,137728,766296,48960,590451,289328,672405,980638,105423,768854,526918,792646,24315,797023,950462,236581,376264,346317,909317,840688,369659,272913,604352,262180,93662,679918,926999,652458,1027168,40076,81240,822205,290160,929024,578708,712494,820595,686891,430308,983904,327687,879899,1019080,344442,814421,1020470,868090,731727,59153,467338,1020882,479269,735793,590248,148614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]