SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020214 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020214 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786493,306268,809033,866119,542124,805535,354380,565676,654058,394555,605800,296200,538042,627328,78942,609039,637225,596138,772494,27206,62243,448850,283864,327704,857039,148324,905819,473145,875286,585564,383698,297666,114112,481439,101348,551543,645760,144963,1008545,406432,897814,906374,1001157,28247,210217,1022955,1030650,510729,114568,494711,823662,25197,397700,175540,606678,141251,821430,841904,307523,91829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002222s ]