SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422093 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422093 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283408,731949,832497,345549,292199,299491,64559,1014014,969660,586355,441602,651278,248435,551647,668757,927984,759054,1005224,371063,727977,917660,866703,354538,441731,957465,383289,925461,559574,669612,374840,381291,1023476,503759,203631,746659,987771,819598,928441,204211,916573,641559,122959,258055,729912,660318,558312,306303,440265,8231,141210,657841,667939,113939,413747,217035,206061,752865,563905,286412,335672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]