SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456641 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456641 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978078,260168,446381,745294,88724,93095,731063,464149,1021321,881980,849761,735353,24464,806644,514478,537260,680544,234478,16290,390639,558136,132190,583548,274001,585244,35312,750800,617951,456188,601043,358070,166066,149973,845432,759717,691216,977685,946885,889281,926112,577001,179810,791628,112811,492211,496201,649538,62439,300656,310573,473372,862416,783398,171233,759889,66414,340045,782383,334086,761621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]