SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 694302 LIMIT 1 [ RunTime:0.000752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 694302 [ RunTime:0.003428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041108,370966,805742,282160,324273,246708,450869,417609,426224,340788,394771,1043120,676776,399068,571394,340292,122127,707039,732904,311310,742669,904283,618385,634156,226120,552109,149104,359739,357580,13816,202720,200244,312883,53972,208606,453909,708843,420202,151769,85185,293360,170383,1007957,7177,781095,930684,336594,685363,1020012,687335,694169,174550,271237,731869,217260,794178,957017,648027,473993,427163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 694302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 694302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002102s ]