SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522571 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522571 [ RunTime:0.004646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638045,713967,729063,611829,844843,909219,971588,213059,861912,130954,1039163,283146,969192,590722,1022340,862665,311555,996641,422114,754581,483093,878251,836670,353220,371187,823940,771438,734479,870451,712119,759111,845033,404850,985312,835934,3756,555185,982329,57259,777698,401370,819113,443114,262813,238655,649265,1012048,372679,635443,244227,149930,710104,135410,880519,482319,163824,381975,3488,13990,831258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]