SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459013 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459013 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901214,371667,445402,368166,590248,667836,380372,1028414,85284,850401,526626,307673,311393,906591,416675,502367,972263,499860,510913,345059,16823,726986,211667,163564,742708,652554,749976,985841,222976,968809,894294,858913,303369,370955,859527,300269,78577,956382,364413,829740,614903,30693,329796,651572,335924,351191,86829,285525,1031680,547729,778552,314421,609993,919977,488986,847996,938139,714605,831407,155198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]