SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545809 LIMIT 1 [ RunTime:0.000735s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545809 [ RunTime:0.005884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815990,955383,143644,276376,224071,730662,970308,437263,930870,257529,864171,819184,65805,565421,805445,562297,399117,417298,118358,787207,327379,966193,510131,999578,689557,568906,286697,875830,348749,998744,282502,19905,190041,325247,115851,949284,920364,272994,207676,338376,115682,402337,648248,781904,377439,725185,502822,984680,518192,753129,408228,728266,341802,386917,438778,103161,643638,70499,981098,89070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]