SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035415 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035415 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787517,338420,10478,41585,52077,43079,107982,229345,424939,554444,68100,109301,372416,750382,271430,244109,795667,126073,961609,988743,902247,170887,579644,573857,654862,564634,712842,42562,455672,54019,421115,40302,588183,1048018,14156,121086,342744,886306,627364,331826,237523,123371,404764,480588,873447,560567,346336,90535,805609,1043162,898871,750630,968169,1047294,466677,868626,631722,238665,18856,860375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]