SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 12643 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 12643 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600213,759545,1045584,732778,21846,439165,741962,477263,101995,983295,994078,230632,99932,462764,577396,133910,316310,502217,432407,159955,225112,232467,648983,999223,991420,380160,176030,125968,643556,654773,1009285,694980,1000724,128732,26057,1002708,470995,6419,705534,173750,861583,286922,246037,420683,216749,442422,300377,407630,1041318,316652,429476,554429,268852,323514,1016544,115946,736416,451643,606812,827922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 12643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 12643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]