SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38102 LIMIT 1 [ RunTime:0.003598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38102 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724209,960965,131346,368924,21623,838677,379017,842594,154782,462363,475223,2691,808391,38655,179273,620919,710064,54724,730285,124993,443588,178133,134748,126278,858024,431349,118073,314808,4664,648214,118788,200647,592201,857864,820214,655538,476548,766253,1011544,296133,836387,73309,936669,334663,73650,576168,652221,947837,315315,524364,364170,350279,737925,921846,190713,705824,198270,250878,441653,625675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004534s ]