SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5104 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5104 [ RunTime:0.003321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878806,973463,485105,487901,190851,458697,622810,343705,695867,364273,208709,262958,193796,998091,915703,619434,480273,330362,150800,561021,1047110,692084,60976,862572,466481,235532,923829,1032148,1035422,107974,301191,695870,705166,613242,365676,178258,444242,53268,521047,730841,153725,382025,943983,439100,437085,821134,194629,746140,398019,757938,210347,499882,581759,695840,174800,168260,416298,903272,601868,577940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001577s ]