SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 66843 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 66843 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990567,741604,226715,1025842,369611,480166,239097,897316,29944,447783,288555,80241,920139,848665,292252,395123,489856,194528,698699,630979,1046212,148091,46721,110584,384632,360470,491822,815770,1040537,920879,841865,832038,458268,738835,940585,559522,959157,72446,925635,551933,390672,865879,251603,242768,275205,379469,50867,475521,273424,477787,232800,578018,802518,272652,764867,13401,40317,395686,596955,415737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 66843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 66843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]