SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20176 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20176 [ RunTime:0.003389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260402,917419,330663,546299,1013911,540424,129081,883866,82621,972351,264694,679676,734106,61762,520044,89404,193287,844847,77328,242230,29854,905344,903533,175575,179747,419125,877949,631428,868753,543592,995531,965126,695251,387601,683117,477119,742327,722301,521762,49924,465392,268494,736939,890462,283447,638879,434351,871290,340071,664395,215846,519368,588631,717704,954848,737678,312530,535309,505916,512751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]