SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53433 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53433 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977080,882635,838263,756418,673858,921821,169555,973314,529447,881823,10121,851127,102244,992581,1028143,613142,410756,75458,110910,899816,890585,237634,336755,295497,967427,1026399,69481,192862,582778,327244,447102,778453,336310,645219,946253,264417,564716,797109,486841,358320,826515,1020924,537799,800019,801783,289803,504642,918523,333666,192831,184425,543936,704599,997543,941156,889583,776917,309892,241863,884481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]