SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284489 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284489 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381918,748435,890154,955662,687914,523394,201555,312236,1008950,848980,706191,474366,416006,1035602,941939,198071,1047346,142130,730773,235728,813965,615105,319442,120121,766058,300087,666625,628690,290119,313928,462945,595594,851788,345832,54490,584024,647596,337325,187655,712427,69173,405699,222798,857375,152363,693383,215922,298364,321909,190168,87765,473567,722819,692290,261699,10582,365148,745448,996909,178655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]