SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511518 LIMIT 1 [ RunTime:0.001258s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511518 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34544,1006068,1013096,310939,893000,445135,777877,240012,813905,155530,968488,938265,880617,876671,1001192,61142,202537,44277,400003,170477,393976,456354,88747,905687,452336,803304,568656,647595,711824,544254,798263,424086,324012,594498,801018,535217,752803,286858,595826,511797,611412,195685,180423,130517,604461,423383,114994,488564,19999,572614,848026,150255,992039,1014511,871432,461062,286972,203203,308120,1038720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]