SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404816 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404816 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013787,140733,595026,168825,841967,694214,438153,43776,648291,267189,588821,629650,286100,406564,872280,592097,438465,352943,76963,98865,977560,500141,784969,324711,598273,48566,179019,942330,754105,342508,673635,293145,34770,643292,758302,217816,488696,475176,109653,534394,475368,944727,746666,554094,488076,342332,549610,649159,329211,273153,662799,882773,1029081,182014,289840,368884,586246,917767,28372,85483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]