SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021641 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021641 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413818,1047249,893789,101088,599222,809906,385679,953133,163399,515398,174284,399660,347171,772893,948265,883654,443221,292259,891411,771471,819566,797147,114352,368382,166111,302704,328110,29840,984764,702022,358630,759482,404453,150079,304989,6820,112370,261088,429426,9876,20435,694866,14449,488817,999883,527849,543249,392336,560946,176161,85377,820253,724683,748741,674572,206373,405520,575661,548308,643347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]