SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391221 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391221 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582612,688180,89582,670888,41357,817124,672109,143120,10875,89824,288333,493613,404220,189940,628444,196711,1004030,769327,265287,459471,497045,257783,157486,380658,137513,835514,96797,725694,196019,660750,205436,486466,824727,1048570,283355,358039,415309,548554,589721,78108,295085,1037237,320524,600364,947574,517250,783930,767723,609119,712249,243298,160846,497875,339912,930638,1005496,785591,906014,505324,923423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]