SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447984 LIMIT 1 [ RunTime:0.001159s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447984 [ RunTime:0.004481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891535,41897,401418,510279,562894,647293,68487,638981,925345,663656,933590,218042,435848,270546,376202,787711,1009175,825223,405076,1014831,451898,844345,627716,745881,267790,400180,858162,246297,406481,783176,507827,94665,430832,97602,1033127,675896,81478,1032998,137331,193050,270524,460248,661759,758272,300410,333154,340098,791271,30309,705779,528364,852158,297153,796998,856477,663945,344231,117578,135014,1028458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]