SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682743 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682743 [ RunTime:0.001449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583982,817052,504989,107044,606052,335475,866224,439668,488774,149168,312914,976536,284106,952814,304522,752433,463585,73201,853400,866585,1025419,549510,519453,282409,740147,264195,546535,195949,920315,491159,686819,141846,713559,334525,277099,1043007,602735,90562,478575,126103,527658,34327,789945,643119,967538,278517,344222,907043,963819,1046914,601796,277562,686944,997455,927655,891354,608034,248926,36166,413645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002706s ]