SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548894 LIMIT 1 [ RunTime:0.001776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548894 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119102,581388,97946,873302,679633,26948,161759,588218,1019065,55884,772318,681583,121350,429016,954035,892034,975247,794188,713601,225020,872252,182188,163839,299098,577920,492602,139796,618645,696256,705693,310651,390697,172528,502521,798628,736333,525592,396842,720099,1003189,109663,359847,540082,959769,334991,581442,604738,933702,924906,518091,948660,179317,788732,744496,545944,1015426,912159,239520,577598,118370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001446s ]