SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54225 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54225 [ RunTime:0.002393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292367,1005623,480606,1003052,374382,521467,108844,362269,218235,1048621,820779,138479,210616,750438,5534,559440,639073,1022483,955950,1583,386402,622098,29870,804541,562730,996980,273810,237291,761816,550147,615948,537499,674395,925626,237679,258565,425828,680712,1031947,170413,970883,127090,22114,1045130,1023212,83756,518063,565934,452198,756008,289776,92909,603048,151238,746248,42406,341112,631192,769353,81634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]