SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003895s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102318 LIMIT 1 [ RunTime:0.002623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102318 [ RunTime:0.006648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789720,520743,722520,288680,137229,407563,244024,678037,773631,592287,246326,231382,242192,576284,576980,376287,228478,579701,416477,132205,591164,536729,27466,692372,812752,357896,219709,709911,346554,343144,318176,661646,578702,12965,738936,74420,724489,763217,648064,959846,994026,103804,181945,872850,259913,698518,692864,534116,661233,699864,737305,656366,608604,633778,447390,365341,961555,815310,856731,931522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001415s ]