SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509311 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509311 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699237,114166,758487,449192,825496,386308,895896,482247,715736,439615,300737,532894,595306,1047895,791037,274825,391716,973305,290498,1040720,577707,102779,124323,927080,277097,999742,634028,248088,610403,230742,175876,796752,450784,492381,961386,980159,122122,490335,127798,88646,230800,687056,472317,526757,368698,105583,373665,432553,654350,372346,123973,179420,446086,997514,350964,106970,447066,859461,258428,378619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]