SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26185 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26185 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415683,183476,341896,78607,589908,565633,22745,171394,674150,32943,300755,870927,599800,367862,880101,335836,576739,137801,835349,425907,781738,591829,1018557,688723,109073,715188,385260,187954,432025,241173,265998,503237,702215,157128,925115,719930,632785,173280,827647,1028903,144511,488844,74938,80167,1040958,1031718,1032367,620786,319247,193092,773535,117797,438460,990726,390687,830739,664340,713268,808603,41288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]