SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43110 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43110 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498822,732730,504974,278514,20630,27930,202583,962317,280715,78399,169147,945083,748560,853584,233678,581116,736314,940976,902597,696755,716345,408118,403185,904455,305257,26236,648909,10920,713284,554647,224907,307883,152208,766897,533738,648511,153778,930782,314267,825270,173679,83676,873304,466142,640592,540639,486792,1000457,857409,577454,323795,777422,235749,554664,358742,602864,264252,1009239,457749,160843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000353s ]