SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171411 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171411 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300271,755185,142401,862289,104868,616776,510811,590132,925497,1044144,2157,659048,92634,801259,636111,936410,138854,832524,145724,88469,762541,110769,961750,491505,800089,738041,349967,15945,78553,244571,153364,937097,666065,890316,683240,213478,788056,133180,798693,985706,271248,186630,647706,817335,749805,648636,300798,868849,76652,1009786,680837,371999,928850,452223,853127,143500,586265,838987,883314,223080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]