SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321051 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321051 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318724,1000807,839031,988779,330141,141733,232233,231860,348977,814945,441050,6606,770310,722696,604459,614828,113733,697954,279530,155073,331935,702743,591261,259669,171603,847828,810493,852453,781147,138043,491270,39497,990868,972943,238773,525047,135363,676768,9339,7295,247933,62557,867705,1000293,263693,122769,299461,80180,804745,834196,512070,170282,546350,137401,740027,793640,622212,280689,818895,584710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]