SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8040 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8040 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83641,518435,984087,983142,497006,561648,576736,401485,675594,602372,908636,205198,175866,281717,1035181,29448,159913,551387,599179,10723,891759,918540,637362,359580,1046915,28026,355222,470352,569601,827296,444334,172495,926248,744950,16557,213112,954726,711348,184596,323535,941178,495977,766597,45767,505842,944054,501248,311851,702797,453881,148068,981403,296406,415154,485943,9686,774053,1002518,287507,269801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]