SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451471 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451471 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401200,1035105,833293,827783,521302,554921,491769,113762,912694,663455,37157,789851,68428,36782,160726,885086,273656,292557,1035393,671082,355376,67597,795480,735194,26767,480676,898224,201741,248537,532580,700475,78895,844362,245858,905816,368516,54635,486677,58693,949578,30231,380892,445045,770622,707738,38040,528775,892446,356521,976350,684288,962315,696502,492502,353474,75121,763105,206785,310684,872651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002838s ]