SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511939 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511939 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810738,495989,1014992,117400,708229,231720,644145,182326,918782,591024,898696,272457,474585,302921,432799,1015566,855854,711061,722881,958023,961694,836324,125191,1026910,764895,315044,594032,898230,554112,886977,1033008,536082,286722,1043493,456836,543298,30735,780076,335163,915400,84213,172031,466776,578722,754977,874146,539803,400136,419564,394583,81093,668862,1020981,605391,755243,970924,456210,779631,1035582,929894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003104s ]