SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261723 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261723 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799079,377603,889490,280959,446824,519771,886,1044489,291331,974657,499975,919902,468937,631592,530120,291470,54315,465369,622214,397788,491115,673189,123909,978933,6178,638789,963845,127710,719524,702792,887067,395442,853012,176443,52897,734591,231740,94630,269043,1019824,207308,855454,422860,159738,774055,628300,923520,693116,731968,759873,94977,206581,123104,120374,405993,132280,401345,653924,9326,682087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]