SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812864 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812864 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939911,997922,558382,336651,415971,97083,452000,1003665,671685,476662,670778,300343,537121,334738,200861,220027,730778,376561,884460,125026,769670,721663,497788,371139,915121,271291,1025864,425047,643149,1001334,1022896,659711,410033,973930,606100,159057,339300,794037,102274,344856,735774,1012601,233893,869861,77421,118651,469726,588748,906316,884021,347300,793088,974891,471532,179218,1550,136773,471808,776135,961452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]