SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536511 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536511 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560518,85182,1032039,632941,193414,645809,675650,28348,634865,5130,639949,535571,75916,974113,521827,234874,247685,153013,10864,639732,186448,449890,89074,288856,931494,413999,254107,1017830,433790,683808,499071,812236,1010650,652618,723253,819476,414216,935893,657571,676865,373876,353309,947789,764635,908403,586979,837855,363273,17054,191372,847011,33095,350004,543897,124244,935642,541826,1018195,947070,627278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]