SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023680 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023680 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71337,306682,391007,631072,358859,40914,481812,734551,164654,826577,985942,103394,1023083,722010,1047273,1008075,798310,942995,941105,1034370,1019441,76986,639889,188160,182375,14780,248929,210075,97072,500514,39342,985156,863906,716071,486922,151181,168894,391384,633664,352112,513334,213566,83096,502512,818685,189479,211459,79309,332999,297523,836229,137502,994421,103775,510228,937767,75352,296082,251090,959272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]