SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261181 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261181 [ RunTime:0.002878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223923,588704,94603,134979,904801,541458,230037,759161,461447,218423,393451,890042,678768,288596,952678,984329,717854,889955,495206,377063,19928,687886,67550,674267,660452,281691,873311,592573,689538,22777,568527,906572,809255,695850,884263,97287,717760,468524,219833,124082,904353,662931,465961,43411,845959,681918,634967,706040,174768,819765,734460,403292,112941,841158,285584,169771,661335,1027480,516006,608198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]