SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509766 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509766 [ RunTime:0.002558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216232,438540,1003705,949583,1034071,10380,1222,638321,415912,237758,693762,546026,590378,564151,972678,246883,446722,228208,180600,310288,271668,939589,347037,382954,641248,1047404,407478,582645,697897,132380,110073,166031,534156,758097,125913,217642,295248,914899,324344,975697,1036257,811601,830058,605337,508690,408135,809964,18697,770600,62698,733166,861581,103890,788219,421513,211604,589152,786938,17459,896891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]