SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038928 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038928 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691231,239449,535249,953879,619043,674722,445316,1031178,524012,967051,645066,30861,471925,448089,986014,2537,442116,980290,425350,594919,980648,1047845,216240,311133,634847,16502,631059,939196,739833,828445,972756,695651,149847,171913,235714,993364,41598,255326,987992,94220,360875,335933,376028,661688,437017,1008003,386604,395005,328015,858449,506929,248236,596587,666072,625755,891660,647825,752305,249891,360080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]