SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422803 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422803 [ RunTime:0.004875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657772,707854,751738,634898,938798,326388,37241,414835,385590,1033032,319968,1000300,20167,64304,628687,325838,824199,613832,835941,202252,151979,982135,462285,305171,566675,954089,219803,959859,32476,920624,892004,927391,160537,759555,1016847,1025535,585983,947083,789345,204751,39818,430762,91598,25221,997858,613273,265560,945407,633414,552811,677977,18949,401228,790317,798889,686633,199286,136650,814045,968633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]