SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022830 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022830 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178352,916918,487504,844837,545359,925836,129089,64565,837993,845016,375613,484481,542016,235588,864288,184883,326110,494255,793306,766095,459566,43484,812763,816946,223954,138735,67942,475909,509092,88324,506166,191693,812216,263051,57008,418352,892547,42547,822412,139766,902147,248905,382368,301156,191730,348840,465649,359670,229292,136239,831772,329694,276849,60645,148162,365576,774273,133516,225577,744237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]