SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26222 LIMIT 1 [ RunTime:0.000780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26222 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848080,173719,959444,444170,454099,853330,506596,971920,921957,488829,942147,80910,953444,101414,478905,515571,385758,1032018,136267,535294,892965,623141,149753,804982,929322,661756,189920,1029757,15731,35138,3651,786357,966984,570919,16770,594749,971256,576451,492829,242751,291509,756073,873039,602725,747609,786339,408536,946526,897989,398936,78326,116263,145272,250487,542889,903447,396414,48068,1041482,197410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002539s ]