SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539072 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539072 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491677,562628,519405,349037,5334,514926,639071,515212,135235,213930,918072,102439,820993,159012,467044,289776,898118,320519,93118,386780,497377,443655,206186,567058,815509,958857,818953,529324,391271,874568,788276,691328,390258,998572,949362,769640,29428,852322,561317,705529,794711,675804,994023,419918,214715,925428,242123,970549,707473,558153,537655,345629,564107,624229,368106,343213,595595,208398,677132,457834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]