SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508938 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508938 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99623,124324,336895,10506,907216,275424,523391,326244,569200,1005218,529975,234050,1045871,795517,147499,479412,786813,1003640,366010,827245,265255,42606,873786,90229,1036524,999106,391609,964634,419906,150068,102429,357452,298799,787478,1046404,702439,805405,37533,452198,18532,689747,997615,287915,749983,935556,157184,1039845,103295,236283,268982,770474,237915,609470,65510,66805,422793,483622,621593,676979,249127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]