SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409063 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409063 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831811,574237,7972,465023,793767,668505,1038951,225851,399802,253328,150225,619876,608085,137442,389557,123043,1040365,220396,1012619,469943,392354,318654,676024,441245,92434,922288,59284,442826,911714,816654,486183,637554,24402,910837,387474,764907,530775,625564,141563,951363,519750,752573,333971,495777,506311,880650,499720,821631,324728,326238,614970,583719,478559,1031985,104502,746888,954946,993890,792310,719880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]