SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523288 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523288 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783817,670258,561651,1026883,293200,1035924,321979,1028625,36031,216638,98244,796591,92098,1036771,230835,581104,1012743,712053,394281,310715,3238,476676,151807,500225,118370,313797,463830,104954,630969,432700,374410,332625,873728,276478,213047,793228,765752,835856,975982,56686,837617,137086,886904,147763,107667,34673,25640,140645,12219,888742,695215,286865,333216,592231,258556,272007,458133,848684,904520,756603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]