SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414777 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414777 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243280,134895,577588,834053,718766,796361,881898,1046073,687422,599219,322187,138512,640550,364722,8362,131829,845361,265893,46424,771404,901485,1039410,508321,185989,138459,156813,359257,834191,378662,166846,88296,194401,551911,646217,54911,726833,457842,1006064,933512,547010,235726,635949,568965,853080,797581,841732,498965,724309,380810,557056,565674,725002,1006927,709864,848071,235296,294891,78404,650517,876131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]