SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555936 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555936 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307216,1037070,395385,798143,628752,377575,235697,320895,267288,1014537,628305,921464,739871,885557,126903,305101,551372,341068,134554,699291,691413,628418,231354,26585,512300,496147,862123,424823,441951,945257,382202,246635,99143,904854,710652,252993,433280,650083,454490,836352,386215,600534,730815,467026,330276,767303,611941,363178,830208,110109,962218,1044328,122153,480997,979949,313476,721651,318251,35384,592107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003925s ]