SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005304 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005304 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612511,366827,172992,48450,548685,162354,208655,483128,358955,552478,367381,792977,286992,399923,591850,24589,518520,358965,368925,689537,60302,308634,139517,1030607,1015266,807160,1015688,9835,1046666,204212,1030970,771614,230328,326298,829064,594034,216664,309065,491664,149064,539633,212187,279408,813687,817267,600212,749266,387165,401862,286790,480595,379965,929826,298700,704498,412525,854334,1034644,428976,575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002452s ]