SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10490 LIMIT 1 [ RunTime:0.001303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10490 [ RunTime:0.002680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334236,989550,913560,169118,813666,327124,590120,55862,73149,533804,719155,888436,375657,374626,431430,347520,794104,868447,1008662,89194,738359,11860,742939,788131,248146,975499,228998,147308,877623,595916,445941,697045,1022242,840726,1000961,397658,883450,333643,950881,936729,521317,169293,213339,923994,531452,966997,878092,651562,490537,807796,778214,59271,863603,598306,690234,834703,419049,810130,6833,227423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001792s ]