SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201624 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201624 [ RunTime:0.002887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354574,600034,369147,745049,483955,146995,602628,166292,465403,145476,923407,449185,177772,695241,683085,130100,696595,670546,160219,221716,438929,270806,462052,807176,1009568,352128,586731,553718,500850,372433,37805,783010,951220,577802,179174,296129,872628,836799,432733,646778,463792,512388,405103,144574,157772,149250,7129,398055,574598,489796,350958,634597,717681,192854,780576,382906,267078,672421,554019,382213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]