SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013101 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013101 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807364,929975,233844,475632,996299,581266,549186,428911,1017853,863361,154002,321853,259210,548690,752658,614186,117367,42802,988080,21545,5593,532812,530812,472437,877099,489218,334164,987159,993309,373541,884311,354160,174921,569498,412636,35654,708045,263468,847645,978002,220209,851931,365669,937358,1013121,713137,301837,987852,229581,314041,694510,982677,528804,190085,467575,59352,458390,574420,6448,214455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001186s ]