SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488194 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488194 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644451,1023507,413187,932004,525237,812173,6271,910934,734250,83138,490665,298684,360665,413584,607566,967050,729457,351643,187343,1014934,276599,37042,940767,655927,1023516,99586,792081,185100,658652,917660,891758,790820,851693,921910,703176,273664,526723,158872,857145,1043731,679379,525242,226353,729668,363903,1038925,401831,25413,878416,1012399,802514,156912,382388,843989,997372,173703,193101,407431,508928,354842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]