SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267454 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267454 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353904,597975,316107,838368,499593,961801,374397,52194,237463,689051,628653,71626,1043102,1004421,392185,117367,554563,547189,86805,39580,209355,542455,345269,256435,926088,1036443,294261,224453,306291,427984,786329,333073,381052,207320,169579,289000,163684,229559,381457,219825,48799,1022540,535701,977497,658549,713646,1012731,840858,374301,203992,454424,316128,488531,288633,699616,199803,446771,457453,3887,543522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002314s ]